--Country
INSERT INTO [CashOrCard].[dbo].[Countries]([CountryName],[IsEnable])
VALUES('Singapore',1)
GO
--Site Type
INSERT INTO [CashOrCard].[dbo].[SiteTypes]([SiteTypeName] ,[SiteTypeDesc],[IsEnable])
VALUES('Hotel','Hotel',1)
GO
INSERT INTO [CashOrCard].[dbo].[SiteTypes]([SiteTypeName] ,[SiteTypeDesc],[IsEnable])
VALUES('Hospital','Hospital',1)
GO
INSERT INTO [CashOrCard].[dbo].[SiteTypes]([SiteTypeName] ,[SiteTypeDesc],[IsEnable])
VALUES('Gas Station','Gas Station',1)
GO
INSERT INTO [CashOrCard].[dbo].[SiteTypes]([SiteTypeName] ,[SiteTypeDesc],[IsEnable])
VALUES('Retail','Retail',1)
GO
INSERT INTO [CashOrCard].[dbo].[SiteTypes]([SiteTypeName] ,[SiteTypeDesc],[IsEnable])
VALUES('Restaurant','Restaurant',1)
GO
INSERT INTO [CashOrCard].[dbo].[SiteTypes]([SiteTypeName] ,[SiteTypeDesc],[IsEnable])
VALUES('Shopping Mall','Shopping Mall',1)
GO
INSERT INTO [CashOrCard].[dbo].[SiteTypes]([SiteTypeName] ,[SiteTypeDesc],[IsEnable])
VALUES('Office','Office',1)
GO

-- CardTypes
INSERT INTO [CashOrCard].[dbo].[CardTypes]([CardTypeName],[ThumbPath],[IsEnable])   
VALUES ('Amex','/Images/Cards/amex-icon.gif',1)
GO
INSERT INTO [CashOrCard].[dbo].[CardTypes]([CardTypeName],[ThumbPath],[IsEnable])   
VALUES ('Master Card','/Images/Cards/master-icon.gif',1)
GO
INSERT INTO [CashOrCard].[dbo].[CardTypes]([CardTypeName],[ThumbPath],[IsEnable])   
VALUES ('Visa','/Images/Cards/visa-icon.gif',1)
GO
INSERT INTO [CashOrCard].[dbo].[CardTypes]([CardTypeName],[ThumbPath],[IsEnable])   
VALUES ('Diners','/Images/Cards/diners-icon.gif',1)
GO
INSERT INTO [CashOrCard].[dbo].[CardTypes]([CardTypeName],[ThumbPath],[IsEnable])   
VALUES ('Union Pay','/Images/Cards/unionpay-icon.gif',1)
GO
INSERT INTO [CashOrCard].[dbo].[CardTypes]([CardTypeName],[ThumbPath],[IsEnable])   
VALUES ('Paypal Card','/Images/Cards/paypal-icon.gif',1)
GO
INSERT INTO [CashOrCard].[dbo].[CardTypes]([CardTypeName],[ThumbPath],[IsEnable])   
VALUES ('Others','/Images/Cards/others-icon.gif',1)
GO

-- CashTypes
INSERT INTO [CashOrCard].[dbo].[CashTypes]
           ([CashTypeName]
           ,[ThumPath]
           ,[IsEnable])
     VALUES
           ('Cash'
           ,NULL
           ,1)
GO
INSERT INTO [CashOrCard].[dbo].[CashTypes]
           ([CashTypeName]
           ,[ThumPath]
           ,[IsEnable])
     VALUES
           ('Cheque'
           ,NULL
           ,1)
GO

--Permissons
INSERT INTO [CashOrCard].[dbo].[Permissions]
           ([Name]
           ,[Description])
     VALUES
           ('usermanagement_access'
           ,NULL)
GO

INSERT INTO [CashOrCard].[dbo].[Permissions]
           ([Name]
           ,[Description])
     VALUES
           ('sitepagemanagement_access'
           ,NULL)
GO

INSERT INTO [CashOrCard].[dbo].[Permissions]
           ([Name]
           ,[Description])
     VALUES
           ('sitemanagement_access'
           ,NULL)
GO

INSERT INTO [CashOrCard].[dbo].[Permissions]
           ([Name]
           ,[Description])
     VALUES
           ('fcmanagement_access'
           ,NULL)
GO

INSERT INTO [CashOrCard].[dbo].[Permissions]
           ([Name]
           ,[Description])
     VALUES
           ('paypalprepaid_access'
           ,NULL)
GO

INSERT INTO [CashOrCard].[dbo].[Permissions]
           ([Name]
           ,[Description])
     VALUES
           ('paymenthistory_access'
           ,NULL)
GO

INSERT INTO [CashOrCard].[dbo].[Permissions]
           ([Name]
           ,[Description])
     VALUES
           ('myprofile_access'
           ,NULL)
GO

INSERT INTO [CashOrCard].[dbo].[Permissions]
           ([Name]
           ,[Description])
     VALUES
           ('password_access'
           ,NULL)
GO


-- Roles
INSERT INTO [CashOrCard].[dbo].[Roles]
           ([RoleName]
           ,[Description]
           ,[IsAdmin])
     VALUES
           ('Admin'
           ,'Admin'
           ,1)
GO

INSERT INTO [CashOrCard].[dbo].[Roles]
           ([RoleName]
           ,[Description]
           ,[IsAdmin])
     VALUES
           ('Business Owner'
           ,'Business Owner'
           ,0)
GO

INSERT INTO [CashOrCard].[dbo].[Roles]
           ([RoleName]
           ,[Description]
           ,[IsAdmin])
     VALUES
           ('Customer'
           ,'Customer'
           ,0)
GO


--Role Permissions
INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (1,1)
GO
INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (2,1)
GO
INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (3,1)
GO
INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (4,1)
GO
INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (6,1)
GO
INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (7,1)
GO
INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (8,1)
GO

INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (3,2)
GO
INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (5,2)
GO
INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (6,2)
GO
INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (7,2)
GO
INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (8,2)
GO

INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (4,3)
GO
INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (5,3)
GO
INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (6,3)
GO
INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (7,3)
GO
INSERT INTO [CashOrCard].[dbo].[PermissionRoles]([Permission_PermissionId] ,[Role_RoleId])
VALUES (8,3)
GO

--Users
INSERT INTO [CashOrCard].[dbo].[Users]
           ([Email]
           ,[FirstName]
           ,[LastName]
           ,[Password]
           ,[ZipCode]
           ,[CompanyName]
           ,[PrimaryPhoneNumber]
           ,[AltPhoneNumber]
           ,[CreateDate]
           ,[LastLoginDate]
           ,[IsApproved]
           ,[IsEnable]
           ,[RoleId]
           ,[Amount])
     VALUES
           ('admin@cashorcard.com.sg',
			'Admin',
			'',
			'40bd2b1edd269605a55e9cae0fecb7a5',
			'250100',
			'CashOrCard Org',
			null,
			null,
			'2013-11-02 00:00:00.000',
			'2013-11-02 00:00:00.000',
			1,
			1,
			1,
			0
			)
GO


--Site Pages
INSERT INTO [CashOrCard].[dbo].[SitePages]
           ([SitePageTitle]
           ,[SitePageSubTitle]
           ,[SitePageBody]
           ,[UserId]
           ,[CreateDate]
           ,[UpdateDate]
           ,[IsEnable])
     VALUES
           ('About'
           ,NULL
           ,'About Page, Demo...'
           ,1
           ,'2013-12-09 00:00:00.000'
           ,'2013-12-09 00:00:00.000'
           ,1)
GO

INSERT INTO [CashOrCard].[dbo].[SitePages]
           ([SitePageTitle]
           ,[SitePageSubTitle]
           ,[SitePageBody]
           ,[UserId]
           ,[CreateDate]
           ,[UpdateDate]
           ,[IsEnable])
     VALUES
           ('Business'
           ,NULL
           ,'Business Page, Demo...'
           ,1
           ,'2013-12-09 00:00:00.000'
           ,'2013-12-09 00:00:00.000'
           ,1)
GO

INSERT INTO [CashOrCard].[dbo].[SitePages]
           ([SitePageTitle]
           ,[SitePageSubTitle]
           ,[SitePageBody]
           ,[UserId]
           ,[CreateDate]
           ,[UpdateDate]
           ,[IsEnable])
     VALUES
           ('MT'
           ,NULL
           ,'MT Page, Demo...'
           ,1
           ,'2013-12-09 00:00:00.000'
           ,'2013-12-09 00:00:00.000'
           ,1)
GO

INSERT INTO [CashOrCard].[dbo].[SitePages]
           ([SitePageTitle]
           ,[SitePageSubTitle]
           ,[SitePageBody]
           ,[UserId]
           ,[CreateDate]
           ,[UpdateDate]
           ,[IsEnable])
     VALUES
           ('JoinUs'
           ,NULL
           ,'Join Us Page, Demo...'
           ,1
           ,'2013-12-09 00:00:00.000'
           ,'2013-12-09 00:00:00.000'
           ,1)
GO






